package com.iflysse.dao;

import com.iflysse.pojo.po.common.CommonPoResp;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.sql.SQLException;

@Repository
public interface StudentSearchRecordDao {
    /**
     * 添加一条学生查询记录
     * @param keywords 关键词
     * @param studentId 学生编号
     * @return
     */
    @Insert({"insert into tb_student_search_record (search_record_id,keywords,student_id,search_time) values (UUID(),#{keywords},#{studentId},now())"})
//    @Options(useGeneratedKeys = true, keyProperty = "search_record_id")
    int addStudentSearchRecord(@Param("keywords") String keywords, @Param("studentId") String studentId) throws SQLException;
}
